How to: Edit a record in the Table Datasheet.
Solution:
Open the Table Datasheet view, go to the record to edit, and modify the desired fields in that record.
1) If the Database window is not active, activate the Database window.
2) Open the Table Datasheet view.
3) Click in the record to be edited.
4) Modify the field(s) in the record as desired:
a) Click in the first field to be edited in that record.
b) Make the desired changes in the field.
c) Click next field to be edited in that record.
d) Repeat steps 4)a) through 4)c) for each field in that record to be edited.
5) Repeat steps 3) and 4) for each record containing fields to be edited.
6) Select the 'File' menu and select 'Save' to save changes.
7) Select the 'File' menu and select 'Close' to close the Table Datasheet view. (The Table Datasheet view closes, and changes are saved automatically if not already saved.)
